www.gusucode.com > VC++ 酒店管理系统-源码程序 > VC++ 酒店管理系统-源码程序/code/hotel2003/GuestInfoLookup.cpp
// GuestInfoLookup.cpp : implementation file // Download by http://www.NewXing.com #include "stdafx.h" #include "qq.h" #include "GuestInfoLookup.h" #ifdef _DEBUG #define new DEBUG_NEW #undef THIS_FILE static char THIS_FILE[] = __FILE__; #endif ///////////////////////////////////////////////////////////////////////////// // CGuestInfoLookup dialog CString CGuestInfoLookup::STRINGS[100]={""}; CGuestInfoLookup::CGuestInfoLookup(CWnd* pParent /*=NULL*/) : CDialog(CGuestInfoLookup::IDD, pParent) { //{{AFX_DATA_INIT(CGuestInfoLookup) //}}AFX_DATA_INIT HandCode = _T("");//初始化数据成员 Name = _T(""); GuestType = _T(""); Sex = _T(""); Certificate = _T(""); CertifyCode = _T(""); IsMember = FALSE; IsMaster = FALSE; GroupID = _T(""); GuestNum = 0; RoomNum = _T(""); RoomCode = _T(""); bSuccess=false; } void CGuestInfoLookup::DoDataExchange(CDataExchange* pDX) { CDialog::DoDataExchange(pDX); //{{AFX_DATA_MAP(CGuestInfoLookup) DDX_Control(pDX, IDC_COMBO1, m_InfoLookup_HandCode); //}}AFX_DATA_MAP } BEGIN_MESSAGE_MAP(CGuestInfoLookup, CDialog) //{{AFX_MSG_MAP(CGuestInfoLookup) //}}AFX_MSG_MAP END_MESSAGE_MAP() ///////////////////////////////////////////////////////////////////////////// // CGuestInfoLookup message handlers void CGuestInfoLookup::OnOK() { // TODO: Add extra validation here CString str; m_InfoLookup_HandCode.GetWindowText(str); if(str=="") { MessageBox("请输入手牌号!","数据为空错误",MB_OK); return ; } //查询数据库,保存查询得到的结果用来显示 /////连接数据库,SQLstr if(!m_GuestInfoSet.Open(AFX_DB_USE_DEFAULT_TYPE)) { MessageBox("打开数据库失败!","数据库错误",MB_OK); bSuccess=false; return ; } bool bInSQL=false;//是否存在这个数据记录 m_GuestInfoSet.MoveFirst(); while(!m_GuestInfoSet.IsEOF()) { if(m_GuestInfoSet.m_HandCode==str) { bInSQL=true; break; } else bInSQL=false; m_GuestInfoSet.MoveNext(); } /////////////////////////////////////////////////////////// // 查询成功的话保存得到的数据 if(bInSQL) { HandCode=m_GuestInfoSet.m_HandCode; Name=m_GuestInfoSet.m_Name; GuestType=m_GuestInfoSet.m_GuestType; Sex=m_GuestInfoSet.m_Sex; Certificate=m_GuestInfoSet.m_Certificate; CertifyCode=m_GuestInfoSet.m_CertifyCode; IsMember=m_GuestInfoSet.m_IsMember; IsMaster=m_GuestInfoSet.m_IsMaster; GroupID=m_GuestInfoSet.m_GroupID; GuestNum=m_GuestInfoSet.m_GuestNum; RoomNum=m_GuestInfoSet.m_RoomNum; RoomCode=m_GuestInfoSet.m_RoomCode; bSuccess=true; } else { MessageBox("该记录不存在!","记录错误",MB_OK); bSuccess=false; m_GuestInfoSet.Close(); return ; } ////保存数据完成关闭数据库 m_GuestInfoSet.Close(); CDialog::OnOK(); } BOOL CGuestInfoLookup::OnInitDialog() { CDialog::OnInitDialog(); HICON m_hIcon=AfxGetApp()->LoadIcon(IDR_MAINFRAME2); this->SetIcon(m_hIcon,true);//设置对话框图标 // TODO: Add extra initialization here m_acCombo.Init(GetDlgItem(IDC_COMBO1)); if(!m_GuestInfoSet.Open(AFX_DB_USE_DEFAULT_TYPE)) { MessageBox("打开数据库失败!","数据库错误",MB_OK); return false; } InitDate();//初始化数组 m_GuestInfoSet.MoveFirst();//move to the first record int i=0; while(!m_GuestInfoSet.IsEOF()) { STRINGS[i]=m_GuestInfoSet.m_HandCode; m_GuestInfoSet.MoveNext(); i++; } m_GuestInfoSet.Close();//关闭数据库 for (int j=0;(!STRINGS[j].IsEmpty()); j++) { m_acCombo.GetStringList().Add(STRINGS[j].GetBuffer(STRINGS[j].GetLength())); } return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE } void CGuestInfoLookup::InitDate() { for(int i=0;i<100;i++) { STRINGS[i]=""; } }